Chicago Sidewalk Cafe Permits

Dataset statistics

Number of variables	22
Number of observations	20115
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.4 MiB
Average record size in memory	176.0 B

Variable types

Numeric	10
Text	5
DateTime	2
Categorical	5

Alerts

`city` has constant value ""	Constant
`state` has constant value ""	Constant
`permit_number` is highly overall correlated with `expiration_date`	High correlation
`address_number_start` is highly overall correlated with `address_number` and 3 other fields	High correlation
`address_number` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`ward` is highly overall correlated with `police_district`	High correlation
`police_district` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`latitude` is highly overall correlated with `address_number_start` and 3 other fields	High correlation
`longitude` is highly overall correlated with `address_number_start` and 2 other fields	High correlation
`expiration_date` is highly overall correlated with `permit_number`	High correlation
`street_type` is highly imbalanced (52.2%)	Imbalance
`permit_number` has unique values	Unique
`address_number_start` has 1238 (6.2%) zeros	Zeros
`address_number` has 1238 (6.2%) zeros	Zeros

Reproduction

Analysis started	2023-11-14 23:06:28.818126
Analysis finished	2023-11-14 23:06:58.120908
Duration	29.3 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

permit_number
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	20115
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1153906.5

Minimum	1000571
Maximum	1862206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1000571
5-th percentile	1024747.2
Q1	1074657
median	1106724
Q3	1131937.5
95-th percentile	1647862.8
Maximum	1862206
Range	861635
Interquartile range (IQR)	57280.5

Descriptive statistics

Standard deviation	180107.75
Coefficient of variation (CV)	0.15608523
Kurtosis	5.2647718
Mean	1153906.5
Median Absolute Deviation (MAD)	25653
Skewness	2.5385618
Sum	2.3210829 × 10¹⁰
Variance	3.2438803 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1556602	1	< 0.1%
1086532	1	< 0.1%
1086551	1	< 0.1%
1086547	1	< 0.1%
1086546	1	< 0.1%
1086538	1	< 0.1%
1086537	1	< 0.1%
1086535	1	< 0.1%
1086534	1	< 0.1%
1086523	1	< 0.1%
Other values (20105)	20105	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000571	1	< 0.1%
1001307	1	< 0.1%
1002652	1	< 0.1%
1002993	1	< 0.1%
1003612	1	< 0.1%
1004393	1	< 0.1%
1007248	1	< 0.1%
1007265	1	< 0.1%
1007306	1	< 0.1%
1007406	1	< 0.1%

Value	Count	Frequency (%)
1862206	1	< 0.1%
1860048	1	< 0.1%
1855208	1	< 0.1%
1854101	1	< 0.1%
1852797	1	< 0.1%
1848630	1	< 0.1%
1848204	1	< 0.1%
1846561	1	< 0.1%
1845400	1	< 0.1%
1844680	1	< 0.1%

account_number
Real number (ℝ)

Distinct	3017
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	205959.18

Minimum	12
Maximum	495456
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	12
5-th percentile	5350
Q1	23077
median	254059
Q3	348409
95-th percentile	414151
Maximum	495456
Range	495444
Interquartile range (IQR)	325332

Descriptive statistics

Standard deviation	156277.56
Coefficient of variation (CV)	0.75877929
Kurtosis	-1.6004864
Mean	205959.18
Median Absolute Deviation (MAD)	144576
Skewness	-0.07715224
Sum	4.1428689 × 10⁹
Variance	2.4422676 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
63414	886	4.4%
65004	312	1.6%
298727	114	0.6%
50161	85	0.4%
22633	66	0.3%
369504	64	0.3%
230211	61	0.3%
267891	48	0.2%
66022	45	0.2%
392906	44	0.2%
Other values (3007)	18390	91.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12	6	< 0.1%
13	21	0.1%
16	4	< 0.1%
27	4	< 0.1%
28	11	0.1%
46	18	0.1%
51	6	< 0.1%
67	20	0.1%
73	17	0.1%
82	2	< 0.1%

Value	Count	Frequency (%)
495456	1	< 0.1%
494737	1	< 0.1%
494267	1	< 0.1%
493688	1	< 0.1%
493621	1	< 0.1%
493348	1	< 0.1%
493334	1	< 0.1%
493192	1	< 0.1%
493107	1	< 0.1%
493069	1	< 0.1%

site_number
Real number (ℝ)

Distinct	100
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3765846

Minimum	1
Maximum	230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	23
Maximum	230
Range	229
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	18.125202
Coefficient of variation (CV)	3.3711367
Kurtosis	41.237255
Mean	5.3765846
Median Absolute Deviation (MAD)	0
Skewness	5.9840194
Sum	108150
Variance	328.52294
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	14712	73.1%
2	2297	11.4%
3	608	3.0%
4	287	1.4%
5	210	1.0%
7	121	0.6%
6	106	0.5%
11	98	0.5%
12	94	0.5%
19	91	0.5%
Other values (90)	1491	7.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	14712	73.1%
2	2297	11.4%
3	608	3.0%
4	287	1.4%
5	210	1.0%
6	106	0.5%
7	121	0.6%
8	65	0.3%
9	63	0.3%
10	67	0.3%

Value	Count	Frequency (%)
230	1	< 0.1%
229	1	< 0.1%
228	1	< 0.1%
226	1	< 0.1%
225	1	< 0.1%
224	1	< 0.1%
221	1	< 0.1%
218	1	< 0.1%
217	1	< 0.1%
211	2	< 0.1%

legal_name
Text

Distinct	3025
Distinct (%)	15.0%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	67
Median length	46
Mean length	21.100224
Min length	4

Characters and Unicode

Total characters	424431
Distinct characters	78
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	680 ?
Unique (%)	3.4%

Sample

1st row	THE LIFEWAY KEFIR SHOP LLC
2nd row	JERRY'S SANDWICHES LS, LLC
3rd row	GOMEZ RESTAURANT LLC
4th row	PLEASANT PIZZA, L.L.C.
5th row	MIR - MUR, INC.,

Value	Count	Frequency (%)
inc	8856	12.9%
llc	6126	8.9%
corporation	1580	2.3%
restaurant	1296	1.9%
	1263	1.8%
starbucks	886	1.3%
chicago	882	1.3%
the	862	1.3%
corp	859	1.2%
cafe	705	1.0%
Other values (3620)	45486	66.1%

Most occurring characters

Value	Count	Frequency (%)
	48842	11.5%
C	30244	7.1%
I	29080	6.9%
A	28334	6.7%
N	27601	6.5%
L	26453	6.2%
O	25667	6.0%
R	25230	5.9%
E	24953	5.9%
T	20568	4.8%
Other values (68)	137459	32.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	333457	78.6%
Space Separator	48842	11.5%
Other Punctuation	26490	6.2%
Lowercase Letter	7883	1.9%
Decimal Number	6929	1.6%
Dash Punctuation	645	0.2%
Close Punctuation	85	< 0.1%
Open Punctuation	85	< 0.1%
Math Symbol	15	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	30244	9.1%
I	29080	8.7%
A	28334	8.5%
N	27601	8.3%
L	26453	7.9%
O	25667	7.7%
R	25230	7.6%
E	24953	7.5%
T	20568	6.2%
S	20231	6.1%
Other values (16)	75096	22.5%

Lowercase Letter

Value	Count	Frequency (%)
a	909	11.5%
e	905	11.5%
n	778	9.9%
o	653	8.3%
t	602	7.6%
r	591	7.5%
i	549	7.0%
s	513	6.5%
c	435	5.5%
l	353	4.5%
Other values (16)	1595	20.2%

Other Punctuation

Value	Count	Frequency (%)
.	11714	44.2%
,	11204	42.3%
'	2276	8.6%
&	1097	4.1%
#	92	0.3%
/	79	0.3%
"	18	0.1%
!	6	< 0.1%
@	2	< 0.1%
:	1	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	1325	19.1%
2	982	14.2%
0	893	12.9%
3	796	11.5%
5	795	11.5%
4	709	10.2%
8	465	6.7%
6	364	5.3%
7	356	5.1%
9	244	3.5%

Space Separator

Value	Count	Frequency (%)
	48842	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	645	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	85	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	85	100.0%

Math Symbol

Value	Count	Frequency (%)
+	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	341340	80.4%
Common	83091	19.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	30244	8.9%
I	29080	8.5%
A	28334	8.3%
N	27601	8.1%
L	26453	7.7%
O	25667	7.5%
R	25230	7.4%
E	24953	7.3%
T	20568	6.0%
S	20231	5.9%
Other values (42)	82979	24.3%

Common

Value	Count	Frequency (%)
	48842	58.8%
.	11714	14.1%
,	11204	13.5%
'	2276	2.7%
1	1325	1.6%
&	1097	1.3%
2	982	1.2%
0	893	1.1%
3	796	1.0%
5	795	1.0%
Other values (16)	3167	3.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	424431	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	48842	11.5%
C	30244	7.1%
I	29080	6.9%
A	28334	6.7%
N	27601	6.5%
L	26453	6.2%
O	25667	6.0%
R	25230	5.9%
E	24953	5.9%
T	20568	4.8%
Other values (68)	137459	32.4%

doing_business_as_name
Text

Distinct	3092
Distinct (%)	15.4%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	88
Median length	45
Mean length	16.847775
Min length	1

Characters and Unicode

Total characters	338893
Distinct characters	77
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	669 ?
Unique (%)	3.3%

Sample

1st row	LIFEWAY KEFIR SHOP
2nd row	JERRY'S SANDWICHES
3rd row	DON PEPE
4th row	BOB'S PIZZA
5th row	The Great American Bagel

Value	Count	Frequency (%)
	2393	4.3%
cafe	1444	2.6%
the	1373	2.5%
coffee	1313	2.3%
restaurant	1269	2.3%
bar	1209	2.2%
grill	1046	1.9%
starbucks	904	1.6%
inc	729	1.3%
and	636	1.1%
Other values (3513)	43588	78.0%

Most occurring characters

Value	Count	Frequency (%)
	35916	10.6%
A	27909	8.2%
E	25845	7.6%
R	20133	5.9%
O	19832	5.9%
S	19381	5.7%
I	17485	5.2%
T	17394	5.1%
N	16778	5.0%
C	14862	4.4%
Other values (67)	123358	36.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	268012	79.1%
Space Separator	35916	10.6%
Lowercase Letter	18888	5.6%
Other Punctuation	9371	2.8%
Decimal Number	6183	1.8%
Dash Punctuation	477	0.1%
Math Symbol	42	< 0.1%
Open Punctuation	2	< 0.1%
Close Punctuation	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	27909	10.4%
E	25845	9.6%
R	20133	7.5%
O	19832	7.4%
S	19381	7.2%
I	17485	6.5%
T	17394	6.5%
N	16778	6.3%
C	14862	5.5%
L	14448	5.4%
Other values (16)	73945	27.6%

Lowercase Letter

Value	Count	Frequency (%)
e	2391	12.7%
a	2308	12.2%
o	1514	8.0%
n	1499	7.9%
r	1377	7.3%
i	1364	7.2%
t	1155	6.1%
l	1110	5.9%
s	1080	5.7%
u	717	3.8%
Other values (15)	4373	23.2%

Other Punctuation

Value	Count	Frequency (%)
'	4092	43.7%
&	1842	19.7%
#	1296	13.8%
.	890	9.5%
,	579	6.2%
/	572	6.1%
"	46	0.5%
!	43	0.5%
@	8	0.1%
;	2	< 0.1%

Decimal Number

Value	Count	Frequency (%)
2	1496	24.2%
1	936	15.1%
4	653	10.6%
3	600	9.7%
5	597	9.7%
0	569	9.2%
7	390	6.3%
6	361	5.8%
9	293	4.7%
8	288	4.7%

Space Separator

Value	Count	Frequency (%)
	35916	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	477	100.0%

Math Symbol

Value	Count	Frequency (%)
+	42	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	286900	84.7%
Common	51993	15.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	27909	9.7%
E	25845	9.0%
R	20133	7.0%
O	19832	6.9%
S	19381	6.8%
I	17485	6.1%
T	17394	6.1%
N	16778	5.8%
C	14862	5.2%
L	14448	5.0%
Other values (41)	92833	32.4%

Common

Value	Count	Frequency (%)
	35916	69.1%
'	4092	7.9%
&	1842	3.5%
2	1496	2.9%
#	1296	2.5%
1	936	1.8%
.	890	1.7%
4	653	1.3%
3	600	1.2%
5	597	1.1%
Other values (16)	3675	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	338893	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	35916	10.6%
A	27909	8.2%
E	25845	7.6%
R	20133	5.9%
O	19832	5.9%
S	19381	5.7%
I	17485	5.2%
T	17394	5.1%
N	16778	5.0%
C	14862	4.4%
Other values (67)	123358	36.4%

issued_date
Date

Distinct	2996
Distinct (%)	14.9%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-10-18 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

expiration_date
Categorical

HIGH CORRELATION

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

12/01/2017	1146
12/01/2016	1143
12/01/2015	1116
02/29/2020	1114
12/01/2014	1112
Other values (23)	14484

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	201150
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	02/28/2022
2nd row	02/28/2022
3rd row	02/28/2022
4th row	02/28/2022
5th row	02/28/2022

Common Values

Value	Count	Frequency (%)
12/01/2017	1146	5.7%
12/01/2016	1143	5.7%
12/01/2015	1116	5.5%
02/29/2020	1114	5.5%
12/01/2014	1112	5.5%
12/01/2013	1083	5.4%
12/01/2012	1034	5.1%
12/01/2018	1022	5.1%
05/31/2021	1018	5.1%
12/01/2011	987	4.9%
Other values (18)	9340	46.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
12/01/2017	1146	5.7%
12/01/2016	1143	5.7%
12/01/2015	1116	5.5%
02/29/2020	1114	5.5%
12/01/2014	1112	5.5%
12/01/2013	1083	5.4%
12/01/2012	1034	5.1%
12/01/2018	1022	5.1%
05/31/2021	1018	5.1%
12/01/2011	987	4.9%
Other values (18)	9340	46.4%

Most occurring characters

Value	Count	Frequency (%)
0	48382	24.1%
2	47084	23.4%
1	46786	23.3%
/	40230	20.0%
8	3653	1.8%
3	3358	1.7%
5	2819	1.4%
9	2600	1.3%
4	2456	1.2%
7	1922	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	160920	80.0%
Other Punctuation	40230	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	48382	30.1%
2	47084	29.3%
1	46786	29.1%
8	3653	2.3%
3	3358	2.1%
5	2819	1.8%
9	2600	1.6%
4	2456	1.5%
7	1922	1.2%
6	1860	1.2%

Other Punctuation

Value	Count	Frequency (%)
/	40230	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	201150	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	48382	24.1%
2	47084	23.4%
1	46786	23.3%
/	40230	20.0%
8	3653	1.8%
3	3358	1.7%
5	2819	1.4%
9	2600	1.3%
4	2456	1.2%
7	1922	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	201150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	48382	24.1%
2	47084	23.4%
1	46786	23.3%
/	40230	20.0%
8	3653	1.8%
3	3358	1.7%
5	2819	1.4%
9	2600	1.3%
4	2456	1.2%
7	1922	1.0%

payment_date
Date

Distinct	2945
Distinct (%)	14.6%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Minimum	2001-03-14 00:00:00
Maximum	2023-10-18 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

address
Text

Distinct	2575
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	34
Median length	23
Mean length	16.682675
Min length	10

Characters and Unicode

Total characters	335572
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	446 ?
Unique (%)	2.2%

Sample

1st row	0 W DIVISION ST
2nd row	4739 N LINCOLN AVE
3rd row	3616 W 26TH ST
4th row	1659 W 21ST ST
5th row	1154 W MADISON ST

Value	Count	Frequency (%)
st	10458	12.9%
n	9114	11.2%
ave	8057	9.9%
w	7263	8.9%
e	1879	2.3%
s	1859	2.3%
0	1238	1.5%
clark	1189	1.5%
wells	1139	1.4%
lincoln	1043	1.3%
Other values (1881)	37931	46.7%

Most occurring characters

Value	Count	Frequency (%)
	61055	18.2%
E	21333	6.4%
S	21159	6.3%
A	20968	6.2%
N	20511	6.1%
T	16683	5.0%
1	12447	3.7%
L	12241	3.6%
I	11531	3.4%
W	11412	3.4%
Other values (26)	126232	37.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	206333	61.5%
Decimal Number	68184	20.3%
Space Separator	61055	18.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	21333	10.3%
S	21159	10.3%
A	20968	10.2%
N	20511	9.9%
T	16683	8.1%
L	12241	5.9%
I	11531	5.6%
W	11412	5.5%
R	10946	5.3%
O	10502	5.1%
Other values (15)	49047	23.8%

Decimal Number

Value	Count	Frequency (%)
1	12447	18.3%
0	10234	15.0%
2	8735	12.8%
3	8200	12.0%
5	7626	11.2%
4	6592	9.7%
6	4474	6.6%
7	4027	5.9%
8	3100	4.5%
9	2749	4.0%

Space Separator

Value	Count	Frequency (%)
	61055	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	206333	61.5%
Common	129239	38.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	21333	10.3%
S	21159	10.3%
A	20968	10.2%
N	20511	9.9%
T	16683	8.1%
L	12241	5.9%
I	11531	5.6%
W	11412	5.5%
R	10946	5.3%
O	10502	5.1%
Other values (15)	49047	23.8%

Common

Value	Count	Frequency (%)
	61055	47.2%
1	12447	9.6%
0	10234	7.9%
2	8735	6.8%
3	8200	6.3%
5	7626	5.9%
4	6592	5.1%
6	4474	3.5%
7	4027	3.1%
8	3100	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	335572	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	61055	18.2%
E	21333	6.4%
S	21159	6.3%
A	20968	6.2%
N	20511	6.1%
T	16683	5.0%
1	12447	3.7%
L	12241	3.6%
I	11531	3.4%
W	11412	3.4%
Other values (26)	126232	37.6%

address_number_start
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1640
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1664.1723

Minimum	0
Maximum	11208
Zeros	1238
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	300
median	1236
Q3	2529
95-th percentile	4857
Maximum	11208
Range	11208
Interquartile range (IQR)	2229

Descriptive statistics

Standard deviation	1628.3622
Coefficient of variation (CV)	0.97848173
Kurtosis	1.3920877
Mean	1664.1723
Median Absolute Deviation (MAD)	1034
Skewness	1.2201973
Sum	33474826
Variance	2651563.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1238	6.2%
200	152	0.8%
1	106	0.5%
111	104	0.5%
2100	95	0.5%
20	91	0.5%
400	90	0.4%
175	86	0.4%
731	81	0.4%
2200	75	0.4%
Other values (1630)	17997	89.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1238	6.2%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

address_number
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1640
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1664.1723

Minimum	0
Maximum	11208
Zeros	1238
Zeros (%)	6.2%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	300
median	1236
Q3	2529
95-th percentile	4857
Maximum	11208
Range	11208
Interquartile range (IQR)	2229

Descriptive statistics

Standard deviation	1628.3622
Coefficient of variation (CV)	0.97848173
Kurtosis	1.3920877
Mean	1664.1723
Median Absolute Deviation (MAD)	1034
Skewness	1.2201973
Sum	33474826
Variance	2651563.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1238	6.2%
200	152	0.8%
1	106	0.5%
111	104	0.5%
2100	95	0.5%
20	91	0.5%
400	90	0.4%
175	86	0.4%
731	81	0.4%
2200	75	0.4%
Other values (1630)	17997	89.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1238	6.2%
1	106	0.5%
2	21	0.1%
5	17	0.1%
6	63	0.3%
7	7	< 0.1%
8	23	0.1%
9	17	0.1%
10	44	0.2%
11	9	< 0.1%

Value	Count	Frequency (%)
11208	1	< 0.1%
11057	1	< 0.1%
10701	10	< 0.1%
10533	2	< 0.1%
10448	1	< 0.1%
9710	1	< 0.1%
8753	1	< 0.1%
8548	9	< 0.1%
8301	1	< 0.1%
8300	1	< 0.1%

street_direction
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

N	9114
W	7263
E	1879
S	1859

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	20115
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	W
2nd row	N
3rd row	W
4th row	W
5th row	W

Common Values

Value	Count	Frequency (%)
N	9114	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	9114	45.3%
w	7263	36.1%
e	1879	9.3%
s	1859	9.2%

Most occurring characters

Value	Count	Frequency (%)
N	9114	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	20115	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	9114	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	20115	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	9114	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20115	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	9114	45.3%
W	7263	36.1%
E	1879	9.3%
S	1859	9.2%

street
Text

Distinct	228
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	24
Median length	13
Mean length	6.8899329
Min length	3

Characters and Unicode

Total characters	138591
Distinct characters	35
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24 ?
Unique (%)	0.1%

Sample

1st row	DIVISION
2nd row	LINCOLN
3rd row	26TH
4th row	21ST
5th row	MADISON

Value	Count	Frequency (%)
clark	1189	5.7%
wells	1139	5.5%
lincoln	1043	5.0%
division	940	4.5%
michigan	729	3.5%
randolph	656	3.2%
southport	617	3.0%
milwaukee	599	2.9%
state	536	2.6%
halsted	500	2.4%
Other values (230)	12877	61.8%

Most occurring characters

Value	Count	Frequency (%)
A	12911	9.3%
L	11717	8.5%
I	11531	8.3%
E	11397	8.2%
N	11397	8.2%
O	10502	7.6%
R	10142	7.3%
S	8882	6.4%
T	6193	4.5%
D	6011	4.3%
Other values (25)	37908	27.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	136954	98.8%
Decimal Number	927	0.7%
Space Separator	710	0.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	12911	9.4%
L	11717	8.6%
I	11531	8.4%
E	11397	8.3%
N	11397	8.3%
O	10502	7.7%
R	10142	7.4%
S	8882	6.5%
T	6193	4.5%
D	6011	4.4%
Other values (15)	36271	26.5%

Decimal Number

Value	Count	Frequency (%)
3	310	33.4%
5	226	24.4%
1	143	15.4%
8	60	6.5%
6	56	6.0%
7	49	5.3%
2	44	4.7%
9	26	2.8%
4	13	1.4%

Space Separator

Value	Count	Frequency (%)
	710	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	136954	98.8%
Common	1637	1.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	12911	9.4%
L	11717	8.6%
I	11531	8.4%
E	11397	8.3%
N	11397	8.3%
O	10502	7.7%
R	10142	7.4%
S	8882	6.5%
T	6193	4.5%
D	6011	4.4%
Other values (15)	36271	26.5%

Common

Value	Count	Frequency (%)
	710	43.4%
3	310	18.9%
5	226	13.8%
1	143	8.7%
8	60	3.7%
6	56	3.4%
7	49	3.0%
2	44	2.7%
9	26	1.6%
4	13	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	138591	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	12911	9.3%
L	11717	8.5%
I	11531	8.3%
E	11397	8.2%
N	11397	8.2%
O	10502	7.6%
R	10142	7.3%
S	8882	6.4%
T	6193	4.5%
D	6011	4.3%
Other values (25)	37908	27.4%

street_type
Categorical

IMBALANCE

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

ST	10418
AVE	8057
RD	608
BLVD	269
PL	255
Other values (4)	508

Length

Max length	4
Median length	2
Mean length	2.4491176
Min length	2

Characters and Unicode

Total characters	49264
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ST
2nd row	AVE
3rd row	ST
4th row	ST
5th row	ST

Common Values

Value	Count	Frequency (%)
ST	10418	51.8%
AVE	8057	40.1%
RD	608	3.0%
BLVD	269	1.3%
PL	255	1.3%
PKWY	199	1.0%
DR	196	1.0%
CT	72	0.4%
HWY	41	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
st	10418	51.8%
ave	8057	40.1%
rd	608	3.0%
blvd	269	1.3%
pl	255	1.3%
pkwy	199	1.0%
dr	196	1.0%
ct	72	0.4%
hwy	41	0.2%

Most occurring characters

Value	Count	Frequency (%)
T	10490	21.3%
S	10418	21.1%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49264	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	10490	21.3%
S	10418	21.1%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49264	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
T	10490	21.3%
S	10418	21.1%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49264	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
T	10490	21.3%
S	10418	21.1%
V	8326	16.9%
A	8057	16.4%
E	8057	16.4%
D	1073	2.2%
R	804	1.6%
L	524	1.1%
P	454	0.9%
B	269	0.5%
Other values (5)	792	1.6%

city
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

CHICAGO	20115

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	140805
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHICAGO
2nd row	CHICAGO
3rd row	CHICAGO
4th row	CHICAGO
5th row	CHICAGO

Common Values

Value	Count	Frequency (%)
CHICAGO	20115	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chicago	20115	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	40230	28.6%
H	20115	14.3%
I	20115	14.3%
A	20115	14.3%
G	20115	14.3%
O	20115	14.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	140805	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	40230	28.6%
H	20115	14.3%
I	20115	14.3%
A	20115	14.3%
G	20115	14.3%
O	20115	14.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	140805	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	40230	28.6%
H	20115	14.3%
I	20115	14.3%
A	20115	14.3%
G	20115	14.3%
O	20115	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	140805	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	40230	28.6%
H	20115	14.3%
I	20115	14.3%
A	20115	14.3%
G	20115	14.3%
O	20115	14.3%

state
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

IL	20115

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	40230
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IL
2nd row	IL
3rd row	IL
4th row	IL
5th row	IL

Common Values

Value	Count	Frequency (%)
IL	20115	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
il	20115	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	20115	50.0%
L	20115	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	40230	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	20115	50.0%
L	20115	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	40230	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	20115	50.0%
L	20115	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	40230	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	20115	50.0%
L	20115	50.0%

zip_code
Real number (ℝ)

Distinct	53
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60625.512

Minimum	60601
Maximum	60707
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	60601
5-th percentile	60602
Q1	60610
median	60618
Q3	60647
95-th percentile	60657
Maximum	60707
Range	106
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	19.889225
Coefficient of variation (CV)	0.00032806692
Kurtosis	-0.68247276
Mean	60625.512
Median Absolute Deviation (MAD)	11
Skewness	0.70024692
Sum	1.2194822 × 10⁹
Variance	395.58127
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60611	1840	9.1%
60654	1768	8.8%
60622	1723	8.6%
60614	1550	7.7%
60657	1420	7.1%
60607	1156	5.7%
60613	981	4.9%
60610	948	4.7%
60647	883	4.4%
60618	835	4.2%
Other values (43)	7011	34.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
60601	652	3.2%
60602	410	2.0%
60603	330	1.6%
60604	234	1.2%
60605	729	3.6%
60606	385	1.9%
60607	1156	5.7%
60608	207	1.0%
60609	31	0.2%
60610	948	4.7%

Value	Count	Frequency (%)
60707	47	0.2%
60661	504	2.5%
60660	199	1.0%
60659	189	0.9%
60657	1420	7.1%
60656	15	0.1%
60655	3	< 0.1%
60654	1768	8.8%
60653	20	0.1%
60651	3	< 0.1%

ward
Real number (ℝ)

HIGH CORRELATION

Distinct	44
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.483619

Minimum	1
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	26
median	42
Q3	43
95-th percentile	47
Maximum	50
Range	49
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	16.40505
Coefficient of variation (CV)	0.52106619
Kurtosis	-0.6761582
Mean	31.483619
Median Absolute Deviation (MAD)	5
Skewness	-0.95202913
Sum	633293
Variance	269.12565
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
42	5554	27.6%
1	1579	7.8%
27	1537	7.6%
47	1476	7.3%
44	1427	7.1%
2	1374	6.8%
43	1186	5.9%
32	1114	5.5%
4	666	3.3%
25	471	2.3%
Other values (34)	3731	18.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1579	7.8%
2	1374	6.8%
3	289	1.4%
4	666	3.3%
5	103	0.5%
6	1	< 0.1%
8	2	< 0.1%
9	1	< 0.1%
10	13	0.1%
11	331	1.6%

Value	Count	Frequency (%)
50	104	0.5%
49	148	0.7%
48	361	1.8%
47	1476	7.3%
46	335	1.7%
45	238	1.2%
44	1427	7.1%
43	1186	5.9%
42	5554	27.6%
41	81	0.4%

police_district
Real number (ℝ)

HIGH CORRELATION

Distinct	23
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.841163

Minimum	0
Maximum	25
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	12
median	18
Q3	19
95-th percentile	20
Maximum	25
Range	25
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	6.8663266
Coefficient of variation (CV)	0.49608017
Kurtosis	-0.40064214
Mean	13.841163
Median Absolute Deviation (MAD)	2
Skewness	-1.0016315
Sum	278415
Variance	47.146441
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
18	5337	26.5%
19	4255	21.2%
1	3656	18.2%
12	2387	11.9%
14	1788	8.9%
20	760	3.8%
16	418	2.1%
17	373	1.9%
24	309	1.5%
2	237	1.2%
Other values (13)	595	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	3656	18.2%
2	237	1.2%
3	10	< 0.1%
4	15	0.1%
5	1	< 0.1%
6	2	< 0.1%
7	1	< 0.1%
8	44	0.2%
9	223	1.1%

Value	Count	Frequency (%)
25	149	0.7%
24	309	1.5%
22	27	0.1%
20	760	3.8%
19	4255	21.2%
18	5337	26.5%
17	373	1.9%
16	418	2.1%
15	7	< 0.1%
14	1788	8.9%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	2567
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.910375

Minimum	41.69067
Maximum	42.019421
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	41.69067
5-th percentile	41.865345
Q1	41.885257
median	41.902442
Q3	41.939274
95-th percentile	41.978062
Maximum	42.019421
Range	0.32875146
Interquartile range (IQR)	0.05401635

Descriptive statistics

Standard deviation	0.037933015
Coefficient of variation (CV)	0.00090509843
Kurtosis	1.7970542
Mean	41.910375
Median Absolute Deviation (MAD)	0.020466559
Skewness	-0.10661154
Sum	843027.2
Variance	0.0014389136
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.88200199	98	0.5%
41.88197573	96	0.5%
41.90405052	85	0.4%
41.87801449	81	0.4%
41.88460018	69	0.3%
41.8825402	53	0.3%
41.90186736	40	0.2%
41.89678605	40	0.2%
41.88216417	37	0.2%
41.87949547	37	0.2%
Other values (2557)	19479	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
41.69066951	1	< 0.1%
41.69139989	2	< 0.1%
41.69245222	1	< 0.1%
41.69920305	10	< 0.1%
41.70289718	1	< 0.1%
41.70356373	2	< 0.1%
41.71874411	1	< 0.1%
41.72107515	10	< 0.1%
41.72112515	1	< 0.1%
41.72177014	1	< 0.1%

Value	Count	Frequency (%)
42.01942097	12	0.1%
42.0193885	5	< 0.1%
42.01934594	4	< 0.1%
42.01933013	3	< 0.1%
42.01932963	2	< 0.1%
42.0193098	4	< 0.1%
42.01927235	1	< 0.1%
42.0174068	8	< 0.1%
42.01615704	15	0.1%
42.01615267	15	0.1%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	2567
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-87.6553

Minimum	-87.834308
Maximum	-87.535139
Zeros	0
Zeros (%)	0.0%
Negative	20115
Negative (%)	100.0%
Memory size	157.3 KiB

Quantile statistics

Minimum	-87.834308
5-th percentile	-87.709805
Q1	-87.672586
median	-87.648962
Q3	-87.629547
95-th percentile	-87.624223
Maximum	-87.535139
Range	0.29916895
Interquartile range (IQR)	0.043038819

Descriptive statistics

Standard deviation	0.033389325
Coefficient of variation (CV)	-0.00038091621
Kurtosis	5.1242084
Mean	-87.6553
Median Absolute Deviation (MAD)	0.020372619
Skewness	-1.7591271
Sum	-1763186.4
Variance	0.001114847
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.63103164	98	0.5%
-87.63397185	96	0.5%
-87.62874675	85	0.4%
-87.63318903	81	0.4%
-87.62798897	69	0.3%
-87.62453095	53	0.3%
-87.62849214	40	0.2%
-87.62828088	40	0.2%
-87.62451427	37	0.2%
-87.63382966	37	0.2%
Other values (2557)	19479	96.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-87.8343079	1	< 0.1%
-87.82625503	9	< 0.1%
-87.82618448	1	< 0.1%
-87.82167425	5	< 0.1%
-87.82042719	4	< 0.1%
-87.81865423	16	0.1%
-87.81795264	4	< 0.1%
-87.81783297	3	< 0.1%
-87.81729036	11	0.1%
-87.8172596	1	< 0.1%

Value	Count	Frequency (%)
-87.53513895	2	< 0.1%
-87.55117213	1	< 0.1%
-87.55124869	1	< 0.1%
-87.55161886	9	< 0.1%
-87.56729719	2	< 0.1%
-87.58184369	4	< 0.1%
-87.58390766	1	< 0.1%
-87.58502961	2	< 0.1%
-87.58781452	8	< 0.1%
-87.58797399	7	< 0.1%

location
Text

Distinct	2567
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Memory size	157.3 KiB

Length

Max length	40
Median length	39
Mean length	39.105543
Min length	35

Characters and Unicode

Total characters	786608
Distinct characters	16
Distinct categories	6 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	445 ?
Unique (%)	2.2%

Sample

1st row	(41.90405051948726, -87.62874675447662)
2nd row	(41.96769881732379, -87.68780818484225)
3rd row	(41.844483527070835, -87.71558453559561)
4th row	(41.853999857174315, -87.66845450091006)
5th row	(41.88173703022226, -87.65654694665614)

Value	Count	Frequency (%)
41.88200198545344	98	0.2%
87.6310316367502	98	0.2%
41.881975727713886	96	0.2%
87.63397184627037	96	0.2%
41.90405051948726	85	0.2%
87.62874675447662	85	0.2%
41.878014487249544	81	0.2%
87.63318903001444	81	0.2%
87.62798896732363	69	0.2%
41.884600177780484	69	0.2%
Other values (5124)	39372	97.9%

Most occurring characters

Value	Count	Frequency (%)
8	84455	10.7%
4	75167	9.6%
7	74159	9.4%
6	72012	9.2%
1	70014	8.9%
9	62712	8.0%
2	53703	6.8%
3	53203	6.8%
5	52643	6.7%
0	47735	6.1%
Other values (6)	140805	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	645803	82.1%
Other Punctuation	60345	7.7%
Open Punctuation	20115	2.6%
Space Separator	20115	2.6%
Dash Punctuation	20115	2.6%
Close Punctuation	20115	2.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
8	84455	13.1%
4	75167	11.6%
7	74159	11.5%
6	72012	11.2%
1	70014	10.8%
9	62712	9.7%
2	53703	8.3%
3	53203	8.2%
5	52643	8.2%
0	47735	7.4%

Other Punctuation

Value	Count	Frequency (%)
.	40230	66.7%
,	20115	33.3%

Open Punctuation

Value	Count	Frequency (%)
(	20115	100.0%

Space Separator

Value	Count	Frequency (%)
	20115	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	20115	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	20115	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	786608	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
8	84455	10.7%
4	75167	9.6%
7	74159	9.4%
6	72012	9.2%
1	70014	8.9%
9	62712	8.0%
2	53703	6.8%
3	53203	6.8%
5	52643	6.7%
0	47735	6.1%
Other values (6)	140805	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	786608	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
8	84455	10.7%
4	75167	9.6%
7	74159	9.4%
6	72012	9.2%
1	70014	8.9%
9	62712	8.0%
2	53703	6.8%
3	53203	6.8%
5	52643	6.7%
0	47735	6.1%
Other values (6)	140805	17.9%

Auto

Heatmap
Table

	permit_number	account_number	site_number	address_number_start	address_number	zip_code	ward	police_district	latitude	longitude	expiration_date	street_direction	street_type
permit_number	1.000	0.473	0.018	-0.174	-0.174	-0.018	-0.082	-0.156	-0.143	0.039	0.872	0.037	0.041
account_number	0.473	1.000	-0.174	-0.123	-0.123	-0.046	-0.108	-0.158	-0.136	0.021	0.270	0.075	0.067
site_number	0.018	-0.174	1.000	-0.122	-0.122	-0.097	0.075	-0.051	-0.074	0.144	0.041	0.069	0.054
address_number_start	-0.174	-0.123	-0.122	1.000	1.000	0.378	0.176	0.513	0.707	-0.745	0.075	0.294	0.210
address_number	-0.174	-0.123	-0.122	1.000	1.000	0.378	0.176	0.513	0.707	-0.745	0.075	0.294	0.210
zip_code	-0.018	-0.046	-0.097	0.378	0.378	1.000	0.177	0.452	0.450	-0.476	0.025	0.307	0.222
ward	-0.082	-0.108	0.075	0.176	0.176	0.177	1.000	0.510	0.453	-0.049	0.031	0.286	0.167
police_district	-0.156	-0.158	-0.051	0.513	0.513	0.452	0.510	1.000	0.813	-0.339	0.079	0.383	0.186
latitude	-0.143	-0.136	-0.074	0.707	0.707	0.450	0.453	0.813	1.000	-0.633	0.088	0.385	0.212
longitude	0.039	0.021	0.144	-0.745	-0.745	-0.476	-0.049	-0.339	-0.633	1.000	0.045	0.321	0.268
expiration_date	0.872	0.270	0.041	0.075	0.075	0.025	0.031	0.079	0.088	0.045	1.000	0.026	0.017
street_direction	0.037	0.075	0.069	0.294	0.294	0.307	0.286	0.383	0.385	0.321	0.026	1.000	0.241
street_type	0.041	0.067	0.054	0.210	0.210	0.222	0.167	0.186	0.212	0.268	0.017	0.241	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	permit_number	account_number	site_number	legal_name	doing_business_as_name	issued_date	expiration_date	payment_date	address	address_number_start	address_number	street_direction	street	street_type	city	state	zip_code	ward	police_district	latitude	longitude	location
0	1556602	328992	1	THE LIFEWAY KEFIR SHOP LLC	LIFEWAY KEFIR SHOP	07/16/2021	02/28/2022	07/16/2021	0 W DIVISION ST	0	0	W	DIVISION	ST	CHICAGO	IL	60622.0	1	18.0	41.904051	-87.628747	(41.90405051948726, -87.62874675447662)
1	1531303	399498	1	JERRY'S SANDWICHES LS, LLC	JERRY'S SANDWICHES	07/16/2021	02/28/2022	07/16/2021	4739 N LINCOLN AVE	4739	4739	N	LINCOLN	AVE	CHICAGO	IL	60625.0	47	19.0	41.967699	-87.687808	(41.96769881732379, -87.68780818484225)
2	1548240	369667	1	GOMEZ RESTAURANT LLC	DON PEPE	07/20/2021	02/28/2022	07/20/2021	3616 W 26TH ST	3616	3616	W	26TH	ST	CHICAGO	IL	60623.0	22	10.0	41.844484	-87.715585	(41.844483527070835, -87.71558453559561)
3	1531318	431422	1	PLEASANT PIZZA, L.L.C.	BOB'S PIZZA	07/23/2021	02/28/2022	07/23/2021	1659 W 21ST ST	1659	1659	W	21ST	ST	CHICAGO	IL	60608.0	25	12.0	41.854000	-87.668455	(41.853999857174315, -87.66845450091006)
4	1533842	457992	1	MIR - MUR, INC.,	The Great American Bagel	07/23/2021	02/28/2022	07/23/2021	1154 W MADISON ST	1154	1154	W	MADISON	ST	CHICAGO	IL	60607.0	25	12.0	41.881737	-87.656547	(41.88173703022226, -87.65654694665614)
5	1548524	457593	1	ODA RESTAURANT LLC	ODA MEDITERRANEAN CUISINE	07/23/2021	02/28/2022	07/23/2021	5657 N CLARK ST	5657	5657	N	CLARK	ST	CHICAGO	IL	60660.0	48	20.0	41.984972	-87.668929	(41.98497216927604, -87.66892851302207)
6	1548849	211324	1	ITALIAN RISTORANTE-HUBBARD, LLC	VERMILION	12/18/2021	02/28/2022	12/18/2021	10 W HUBBARD ST	10	10	W	HUBBARD	ST	CHICAGO	IL	60654.0	42	18.0	41.890169	-87.628394	(41.89016858549094, -87.62839433601951)
7	1685995	360952	1	AMY'S CANDY BAR INC.	Amy's Candy Bar	06/14/2022	02/28/2023	06/14/2022	0 N DAMEN AVE	0	0	N	DAMEN	AVE	CHICAGO	IL	60625.0	47	12.0	41.881359	-87.676789	(41.881358617173056, -87.67678939121616)
8	1643969	463188	1	ETTA RIVER NORTH, LLC	ETTA	03/09/2022	02/28/2023	02/24/2022	0 N CLARK ST	0	0	N	CLARK	ST	CHICAGO	IL	60654.0	2	1.0	41.882002	-87.631032	(41.88200198545344, -87.6310316367502)
9	1640992	370467	4	GEB, LLC	THE BANDIT	03/09/2022	02/28/2023	03/09/2022	0 W RANDOLPH ST	0	0	W	RANDOLPH	ST	CHICAGO	IL	60607.0	27	1.0	41.884600	-87.627989	(41.884600177780484, -87.62798896732363)

	permit_number	account_number	site_number	legal_name	doing_business_as_name	issued_date	expiration_date	payment_date	address	address_number_start	address_number	street_direction	street	street_type	city	state	zip_code	ward	police_district	latitude	longitude	location
20105	1806794	308271	1	KATHY A DECARLO	KATHY DE'S	06/20/2023	02/29/2024	06/20/2023	3642 S PARNELL AVE	3642	3642	S	PARNELL	AVE	CHICAGO	IL	60609.0	11	9.0	41.827725	-87.640085	(41.82772496307889, -87.64008519409887)
20106	1782191	421767	2	DOLLOP WELLS LLC	Dollop Coffee bar	06/20/2023	02/29/2024	06/20/2023	0 N WELLS ST	0	0	N	WELLS	ST	CHICAGO	IL	60610.0	27	1.0	41.881976	-87.633972	(41.881975727713886, -87.63397184627037)
20107	1823617	468560	1	BUREAU BAR AND RESTAURANT LLC	BUREAU BAR AND RESTAURANT	06/21/2023	02/29/2024	06/21/2023	0 S STATE ST	0	0	S	STATE	ST	CHICAGO	IL	60616.0	3	1.0	41.881960	-87.627937	(41.881960316026536, -87.6279372789252)
20108	1809045	486915	1	River North Egg Harbor, LLC	Egg Harbor Cafe	06/21/2023	02/29/2024	06/21/2023	800 N WELLS ST	800	800	N	WELLS	ST	CHICAGO	IL	60610.0	27	18.0	41.896634	-87.634351	(41.8966337490024, -87.63435133722824)
20109	1813742	384562	1	TACOS TEQUILAS ON THE LAKE, INC.	TACOS TEQUILAS	06/21/2023	02/29/2024	06/21/2023	2919 N MILWAUKEE AVE	2919	2919	N	MILWAUKEE	AVE	CHICAGO	IL	60618.0	35	14.0	41.934393	-87.715900	(41.934392894503155, -87.71589988857131)
20110	1816017	490229	1	LA ESQUINA DEL TACO INC.,	LA ESQUINA DEL TACO	06/21/2023	02/29/2024	06/21/2023	3259 W 63RD ST	3259	3259	W	63RD	ST	CHICAGO	IL	60629.0	14	8.0	41.778828	-87.705434	(41.77882757627881, -87.70543426650146)
20111	1827202	482604	2	PWU DUMMY ACCOUNT	PWU DUMMY ACCOUNT	06/22/2023	02/29/2024	06/22/2023	3328 N LINCOLN AVE	3328	3328	N	LINCOLN	AVE	CHICAGO	IL	60657.0	32	19.0	41.942385	-87.670714	(41.94238547241118, -87.67071383788313)
20112	1828620	7533	1	LA BRUQUENA RESTAURANT & LOUNGE, INC.	LA BRUQUENA RESTAURANT & LOUNGE	06/23/2023	02/29/2024	06/23/2023	0 W DIVISION ST	0	0	W	DIVISION	ST	CHICAGO	IL	60622.0	26	18.0	41.904051	-87.628747	(41.90405051948726, -87.62874675447662)
20113	1815670	294329	1	RICHMOND TAVERN, INC.	RICHMOND TAVERN	06/27/2023	02/29/2024	06/27/2023	2944 W GRAND AVE	2944	2944	W	GRAND	AVE	CHICAGO	IL	60622.0	36	12.0	41.896089	-87.700748	(41.89608917059594, -87.70074823336402)
20114	1804536	474539	2	PEDESTRIAN COFFEE LLC	THE COFFEE STUDIO	06/27/2023	02/29/2024	06/27/2023	5628 N CLARK ST	5628	5628	N	CLARK	ST	CHICAGO	IL	60660.0	40	20.0	41.984385	-87.669099	(41.984384824892075, -87.66909931387195)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Close Punctuation

Open Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Math Symbol

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters